﻿CREATE PROCEDURE [dbo].[GetProject]
@ProjectID INT
AS
SELECT 
	name, Description, ManagerUserID, EstCompletionDate, EstDuration, ProjectTypeID,
		COALESCE(StatusID, 1) AS StatusID,
		COALESCE(BilledAsOf, '1/1/2000') AS BilledAsOf

FROM 
	Projects

WHERE 
	ProjectID = @ProjectID

exec ListMembers @ProjectID


